UPDATE C1_USER_GROUP_PERMISSION SET END_DATE = SYSDATE, DATA_STATE_CODE = '0' WHERE
INSTR(','||:userGroupPermissionIds||',', ','||USER_GROUP_PERMISSION_ID||',') > 0